// 期初科目余额
const {DataTypes, db } = require("../db");
db.define('initSubjectYe', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
buId:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
buName:{type: DataTypes.STRING(200),allowNull:false,comment:''}, 
subjectId:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
subjectCode:{type: DataTypes.STRING(100),allowNull:false,comment:''}, 
subjectName:{type: DataTypes.STRING(100),allowNull:false,comment:''}, 
fullName:{type: DataTypes.STRING(100),allowNull:false,comment:''}, 
price1:{type: DataTypes.DECIMAL(20, 2),allowNull:false,comment:''}, 
price2:{type: DataTypes.DECIMAL(20, 2),allowNull:false,comment:''}, 
billDate:{type: DataTypes.STRING(10),comment:''}, 

}, {
    tableName: 'init_subject_ye',
    timestamps: false,
    comment: '期初科目余额'
});